BrandedTenderMedia

Entity Definition

Logical Name : BrandedTenderMedia
Physical Name : CO_BRN_TND_MD

Identifies debit/credit card and stored value tender types that are co-branded. This allows credit debit cards (whcih can be designated as Mastercard, AMEX, Visa, Discover, etc. from the AccountNumber) to be further defined by co-branding. For example CaptialOne Visa, Marriott Visa, etc. The co-branding may be associated with promotional offers (and upstream with promotional campaigns) that need to be reflected in the PriceDerivationRuleElgibility set of entities. These entities define the condiitions that trigger the application of a discount (PriceDerivationRule). In addition to credit/debit cards branded tender media can apply to stored value cards. AirMiles is one example. It is possible to link speciic promotions to specific branded store value tender media. NOTE: We use the term "card" here but it is possible that another form of tender token can be used on smart phones. These are electronic wallets like Google Wallet, etc. For our purposes, these are logically all stored value tender "containers".

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TenderMediaBrandID (PK) Token identifier for a tender media brand. ID_TND_MD_BRN Identity integer
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. Sample Values: CASH - currency CREDIT - credit card DEBIT - debit card CUST_ACCT - customer credit account with retailer EBT - electronic benefits transfer CHEQUE - personal or business cheque STORED_VALUE - gift cert. or gift card COUPON - mfg coupon VOUCHER - retailer issued debit (e.g. coinstar voucher) SEND_CHECK - paid out/refund via acct pay. TRADEIN - trade in kind/trade in debit OTHER - other debit offset tender type TY_TND Code varchar(20) Tender(AS_TND)
CoBrandName The trade name used to differentiate the tender media for a specific sponsor from other generic or sponsored tender media that belongs to the same tender type. For example: TenderType: CreditCard-VISA (from account) CoBrandName: CaptialOne or GIANT VIsa (co branded for a retailer. NM_CO_BRN DescriptionShort varchar(255)
TenderMediaCoSponsorID (FK) Token identifier for an organization that sponsors a particular brand of tender media. Examples include Marriott VISA credit card, US AIR Master card, etc. ID_TND_MD_COSPNSR Identity integer TenderMediaCoSponsor(PA_TND_MD_COSPNSR)

Relationships

Parent Entity Verb Phrase Child Entity
Tender is promoted as BrandedTenderMedia
TenderMediaCoSponsor co-sponsors BrandedTenderMedia
BrandedTenderMedia is basis for BrandedTenderMediaPromotionRewardEligibility
BrandedTenderMedia is used as settlement TenderLineItem
BrandedTenderMedia identifies branded tender for ExternalPurchasedCreditDebitCardSpendData

Logical Views containing BrandedTenderMedia

Logical View
Logical 07040 - Customer Segment Dependent Behavior
Logical 07042 - Customer Wallet Share